create external table jms_dm.dm_end_dispatch_store_level_cnt_dt 
(
  agent_code string COMMENT '代理区编码  ', 
  agent_name string COMMENT '代理区名称', 
  franchisee_code string COMMENT '加盟商code', 
  franchisee_name string COMMENT '加盟商name', 
  virt_code string COMMENT '虚拟代理区code', 
  virt_name string COMMENT '虚拟代理区name', 
  network_code string COMMENT '网点编码', 
  network_name string COMMENT '网点名称', 
  score_level string COMMENT '等级', 
  store_cnt int COMMENT '驿站数量', 
  score_avg decimal(16,2) COMMENT '平均得分', 
  date_time date COMMENT '查询日期', 
  business_id string COMMENT '品牌id', 
  business_name string COMMENT '品牌名稱'
)
comment '末端驿站分层汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_end_dispatch_store_level_cnt_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
